package com.itheima.health.mapper;

import org.apache.ibatis.annotations.Select;
import org.mybatis.spring.annotation.MapperScan;

import java.util.List;
import java.util.Map;

@MapperScan
public interface StatisticsOfMapper {


    //查询套餐购买占比   //查询订单表

    @Select("SELECT COUNT(tor.SETMEAL_ID) AS 'value' ,ts.name FROM t_setmeal ts , t_order tor  WHERE ts.ID = tor.SETMEAL_ID  GROUP BY tor.SETMEAL_ID")
    List<Map> selectStatisticsOf();
}
